Structured Query Language-SQL: Using Oracle SQL Plus by Francis John Thottungal

Author:Francis John Thottungal
Language: eng
Format: azw3
Published: 2017-07-17T07:00:00+00:00

Single row sub queries will use single row comparison operators such as (=, >, <=, >=, <, <>).

Let us look at this example of a single row sub query:

select name from staff

where job = (select job from staff where sid ='103') or

salary > (select salary from staff where sid = '104');

The result will be as follows:

The single row sub query is different from the first example in this chapter because it has two sub queries connected by an OR logical operator.

Group functions can be used in a sub query.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.